Configuring buffer pools in DB2 UDB

Database Management Systems (DBMSs) use a main memory area as a buffer to reduce the number of disk accesses performed by a transaction. DB2 Universal Database divides the buffer area into a number of independent buffer pools and each database object (table or index) is assigned to a specific buffer pool. The tasks of configuring the buffer pools, which defines the mapping of database objects to buffer pools and setting a size for each of the buffer pools, is crucial for achieving optimal performance.